Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	11939
Missing cells	12924
Missing cells (%)	3.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.6 MiB
Average record size in memory	926.7 B

Variable types

Numeric	15
Categorical	18

Warnings

`country` has a high cardinality: 109 distinct values	High cardinality
`reservation_status_date` has a high cardinality: 852 distinct values	High cardinality
`df_index` is highly correlated with `agent`	High correlation
`arrival_date_year` is highly correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly correlated with `arrival_date_year`	High correlation
`agent` is highly correlated with `df_index`	High correlation
`df_index` is highly correlated with `agent`	High correlation
`arrival_date_year` is highly correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly correlated with `arrival_date_year`	High correlation
`is_repeated_guest` is highly correlated with `previous_bookings_not_canceled`	High correlation
`previous_bookings_not_canceled` is highly correlated with `is_repeated_guest`	High correlation
`agent` is highly correlated with `df_index`	High correlation
`is_repeated_guest` is highly correlated with `previous_bookings_not_canceled`	High correlation
`previous_bookings_not_canceled` is highly correlated with `is_repeated_guest`	High correlation
`arrival_date_week_number` is highly correlated with `arrival_date_month` and 3 other fields	High correlation
`hotel` is highly correlated with `agent` and 3 other fields	High correlation
`is_canceled` is highly correlated with `df_index` and 1 other fields	High correlation
`arrival_date_month` is highly correlated with `arrival_date_week_number` and 1 other fields	High correlation
`agent` is highly correlated with `hotel` and 2 other fields	High correlation
`stays_in_weekend_nights` is highly correlated with `stays_in_week_nights`	High correlation
`df_index` is highly correlated with `arrival_date_week_number` and 6 other fields	High correlation
`lead_time` is highly correlated with `company`	High correlation
`assigned_room_type` is highly correlated with `hotel` and 2 other fields	High correlation
`deposit_type` is highly correlated with `reservation_status`	High correlation
`reservation_status` is highly correlated with `is_canceled` and 2 other fields	High correlation
`stays_in_week_nights` is highly correlated with `stays_in_weekend_nights` and 1 other fields	High correlation
`company` is highly correlated with `arrival_date_week_number` and 6 other fields	High correlation
`arrival_date_year` is highly correlated with `arrival_date_week_number` and 2 other fields	High correlation
`previous_cancellations` is highly correlated with `previous_bookings_not_canceled`	High correlation
`market_segment` is highly correlated with `company` and 1 other fields	High correlation
`reserved_room_type` is highly correlated with `assigned_room_type` and 1 other fields	High correlation
`previous_bookings_not_canceled` is highly correlated with `previous_cancellations`	High correlation
`distribution_channel` is highly correlated with `market_segment`	High correlation
`children` is highly correlated with `assigned_room_type` and 1 other fields	High correlation
`market_segment` is highly correlated with `distribution_channel`	High correlation
`assigned_room_type` is highly correlated with `reserved_room_type`	High correlation
`reservation_status` is highly correlated with `is_canceled`	High correlation
`reserved_room_type` is highly correlated with `assigned_room_type`	High correlation
`is_canceled` is highly correlated with `reservation_status`	High correlation
`distribution_channel` is highly correlated with `market_segment`	High correlation
`agent` has 1635 (13.7%) missing values	Missing
`company` has 11241 (94.2%) missing values	Missing
`adults` is highly skewed (γ1 = 20.76322339)	Skewed
`previous_cancellations` is highly skewed (γ1 = 23.75659833)	Skewed
`previous_bookings_not_canceled` is highly skewed (γ1 = 21.99555117)	Skewed
`df_index` has unique values	Unique
`lead_time` has 635 (5.3%) zeros	Zeros
`stays_in_weekend_nights` has 5276 (44.2%) zeros	Zeros
`stays_in_week_nights` has 771 (6.5%) zeros	Zeros
`previous_cancellations` has 11325 (94.9%) zeros	Zeros
`previous_bookings_not_canceled` has 11560 (96.8%) zeros	Zeros
`booking_changes` has 10139 (84.9%) zeros	Zeros
`days_in_waiting_list` has 11561 (96.8%) zeros	Zeros
`adr` has 204 (1.7%) zeros	Zeros
`total_of_special_requests` has 7020 (58.8%) zeros	Zeros

Reproduction

Analysis started	2022-01-18 20:55:08.782011
Analysis finished	2022-01-18 20:55:54.372008
Duration	45.59 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	11939
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59706.35053

Minimum	5
Maximum	119388
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	5
5-th percentile	5590.4
Q1	29931.5
median	59416
Q3	89234
95-th percentile	113493.1
Maximum	119388
Range	119383
Interquartile range (IQR)	59302.5

Descriptive statistics

Standard deviation	34480.59589
Coefficient of variation (CV)	0.5775029888
Kurtosis	-1.191425583
Mean	59706.35053
Median Absolute Deviation (MAD)	29642
Skewness	0.002508635686
Sum	712834119
Variance	1188911493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22525	1	< 0.1%
118344	1	< 0.1%
87400	1	< 0.1%
60775	1	< 0.1%
9574	1	< 0.1%
68963	1	< 0.1%
38166	1	< 0.1%
100338	1	< 0.1%
71008	1	< 0.1%
102670	1	< 0.1%
Other values (11929)	11929	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	1	< 0.1%
9	1	< 0.1%
24	1	< 0.1%
62	1	< 0.1%
71	1	< 0.1%
74	1	< 0.1%
78	1	< 0.1%
80	1	< 0.1%
84	1	< 0.1%
85	1	< 0.1%

Value	Count	Frequency (%)
119388	1	< 0.1%
119362	1	< 0.1%
119361	1	< 0.1%
119344	1	< 0.1%
119321	1	< 0.1%
119305	1	< 0.1%
119302	1	< 0.1%
119298	1	< 0.1%
119294	1	< 0.1%
119292	1	< 0.1%

hotel
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	789.1 KiB

City Hotel	7931
Resort Hotel	4008

Length

Max length	12
Median length	10
Mean length	10.67141302
Min length	10

Characters and Unicode

Total characters	127406
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	City Hotel
2nd row	Resort Hotel
3rd row	City Hotel
4th row	City Hotel
5th row	City Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	7931	66.4%
Resort Hotel	4008	33.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
hotel	11939	50.0%
city	7931	33.2%
resort	4008	16.8%

Most occurring characters

Value	Count	Frequency (%)
t	23878	18.7%
o	15947	12.5%
e	15947	12.5%
	11939	9.4%
H	11939	9.4%
l	11939	9.4%
C	7931	6.2%
i	7931	6.2%
y	7931	6.2%
R	4008	3.1%
Other values (2)	8016	6.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91589	71.9%
Uppercase Letter	23878	18.7%
Space Separator	11939	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	23878	26.1%
o	15947	17.4%
e	15947	17.4%
l	11939	13.0%
i	7931	8.7%
y	7931	8.7%
s	4008	4.4%
r	4008	4.4%

Uppercase Letter

Value	Count	Frequency (%)
H	11939	50.0%
C	7931	33.2%
R	4008	16.8%

Space Separator

Value	Count	Frequency (%)
	11939	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	115467	90.6%
Common	11939	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	23878	20.7%
o	15947	13.8%
e	15947	13.8%
H	11939	10.3%
l	11939	10.3%
C	7931	6.9%
i	7931	6.9%
y	7931	6.9%
R	4008	3.5%
s	4008	3.5%

Common

Value	Count	Frequency (%)
	11939	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127406	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	23878	18.7%
o	15947	12.5%
e	15947	12.5%
	11939	9.4%
H	11939	9.4%
l	11939	9.4%
C	7931	6.2%
i	7931	6.2%
y	7931	6.2%
R	4008	3.1%
Other values (2)	8016	6.3%

is_canceled
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

0	7526
1	4413

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

Most occurring characters

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11939	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11939	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7526	63.0%
1	4413	37.0%

lead_time
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	445
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.2650976

Minimum	0
Maximum	629
Zeros	635
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	17
median	67
Q3	159
95-th percentile	316
Maximum	629
Range	629
Interquartile range (IQR)	142

Descriptive statistics

Standard deviation	105.9764844
Coefficient of variation (CV)	1.036291823
Kurtosis	1.799286001
Mean	102.2650976
Median Absolute Deviation (MAD)	58
Skewness	1.371569719
Sum	1220943
Variance	11231.01524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	635	5.3%
1	347	2.9%
2	216	1.8%
3	175	1.5%
5	165	1.4%
4	150	1.3%
6	145	1.2%
7	142	1.2%
8	116	1.0%
10	115	1.0%
Other values (435)	9733	81.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	635	5.3%
1	347	2.9%
2	216	1.8%
3	175	1.5%
4	150	1.3%
5	165	1.4%
6	145	1.2%
7	142	1.2%
8	116	1.0%
9	110	0.9%

Value	Count	Frequency (%)
629	3	< 0.1%
626	3	< 0.1%
622	4	< 0.1%
615	2	< 0.1%
608	2	< 0.1%
605	3	< 0.1%
601	1	< 0.1%
594	1	< 0.1%
587	3	< 0.1%
580	1	< 0.1%

arrival_date_year
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

2016	5697
2017	4081
2015	2161

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	47756
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2016
3rd row	2015
4th row	2017
5th row	2016

Common Values

Value	Count	Frequency (%)
2016	5697	47.7%
2017	4081	34.2%
2015	2161	18.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2016	5697	47.7%
2017	4081	34.2%
2015	2161	18.1%

Most occurring characters

Value	Count	Frequency (%)
2	11939	25.0%
0	11939	25.0%
1	11939	25.0%
6	5697	11.9%
7	4081	8.5%
5	2161	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	47756	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11939	25.0%
0	11939	25.0%
1	11939	25.0%
6	5697	11.9%
7	4081	8.5%
5	2161	4.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	47756	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11939	25.0%
0	11939	25.0%
1	11939	25.0%
6	5697	11.9%
7	4081	8.5%
5	2161	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47756	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11939	25.0%
0	11939	25.0%
1	11939	25.0%
6	5697	11.9%
7	4081	8.5%
5	2161	4.5%

arrival_date_month
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	733.4 KiB

August	1346
July	1249
May	1223
April	1117
October	1115
Other values (7)	5889

Length

Max length	9
Median length	6
Mean length	5.8947148
Min length	3

Characters and Unicode

Total characters	70377
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	November
2nd row	April
3rd row	December
4th row	January
5th row	April

Common Values

Value	Count	Frequency (%)
August	1346	11.3%
July	1249	10.5%
May	1223	10.2%
April	1117	9.4%
October	1115	9.3%
June	1087	9.1%
September	995	8.3%
March	965	8.1%
February	835	7.0%
December	711	6.0%
Other values (2)	1296	10.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	1346	11.3%
july	1249	10.5%
may	1223	10.2%
april	1117	9.4%
october	1115	9.3%
june	1087	9.1%
september	995	8.3%
march	965	8.1%
february	835	7.0%
december	711	6.0%
Other values (2)	1296	10.9%

Most occurring characters

Value	Count	Frequency (%)
e	9511	13.5%
r	7869	11.2%
u	6481	9.2%
b	4334	6.2%
a	4259	6.1%
y	3925	5.6%
t	3456	4.9%
J	2954	4.2%
c	2791	4.0%
A	2463	3.5%
Other values (16)	22334	31.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	58438	83.0%
Uppercase Letter	11939	17.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	9511	16.3%
r	7869	13.5%
u	6481	11.1%
b	4334	7.4%
a	4259	7.3%
y	3925	6.7%
t	3456	5.9%
c	2791	4.8%
m	2384	4.1%
l	2366	4.0%
Other values (8)	11062	18.9%

Uppercase Letter

Value	Count	Frequency (%)
J	2954	24.7%
A	2463	20.6%
M	2188	18.3%
O	1115	9.3%
S	995	8.3%
F	835	7.0%
D	711	6.0%
N	678	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	70377	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	9511	13.5%
r	7869	11.2%
u	6481	9.2%
b	4334	6.2%
a	4259	6.1%
y	3925	5.6%
t	3456	4.9%
J	2954	4.2%
c	2791	4.0%
A	2463	3.5%
Other values (16)	22334	31.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70377	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	9511	13.5%
r	7869	11.2%
u	6481	9.2%
b	4334	6.2%
a	4259	6.1%
y	3925	5.6%
t	3456	4.9%
J	2954	4.2%
c	2791	4.0%
A	2463	3.5%
Other values (16)	22334	31.7%

arrival_date_week_number
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.06868247

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	27
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.70172554
Coefficient of variation (CV)	0.5061836885
Kurtosis	-0.993153523
Mean	27.06868247
Median Absolute Deviation (MAD)	11
Skewness	0.009828044899
Sum	323173
Variance	187.7372827
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	340	2.8%
30	317	2.7%
20	316	2.6%
25	291	2.4%
34	290	2.4%
32	288	2.4%
29	287	2.4%
17	286	2.4%
18	286	2.4%
41	275	2.3%
Other values (43)	8963	75.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	106	0.9%
2	126	1.1%
3	124	1.0%
4	175	1.5%
5	136	1.1%
6	157	1.3%
7	214	1.8%
8	245	2.1%
9	211	1.8%
10	189	1.6%

Value	Count	Frequency (%)
53	211	1.8%
52	115	1.0%
51	92	0.8%
50	147	1.2%
49	187	1.6%
48	156	1.3%
47	150	1.3%
46	161	1.3%
45	203	1.7%
44	223	1.9%

arrival_date_day_of_month
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.97470475

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	24
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.742890086
Coefficient of variation (CV)	0.5472958795
Kurtosis	-1.173654697
Mean	15.97470475
Median Absolute Deviation (MAD)	8
Skewness	-0.02684347686
Sum	190722
Variance	76.43812706
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	468	3.9%
15	453	3.8%
24	443	3.7%
5	432	3.6%
12	424	3.6%
20	420	3.5%
19	416	3.5%
28	414	3.5%
27	410	3.4%
25	409	3.4%
Other values (21)	7650	64.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	363	3.0%
2	363	3.0%
3	392	3.3%
4	342	2.9%
5	432	3.6%
6	350	2.9%
7	362	3.0%
8	386	3.2%
9	401	3.4%
10	371	3.1%

Value	Count	Frequency (%)
31	219	1.8%
30	388	3.2%
29	370	3.1%
28	414	3.5%
27	410	3.4%
26	385	3.2%
25	409	3.4%
24	443	3.7%
23	367	3.1%
22	360	3.0%

stays_in_weekend_nights
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9141469135

Minimum	0
Maximum	9
Zeros	5276
Zeros (%)	44.2%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.987058179
Coefficient of variation (CV)	1.079758805
Kurtosis	3.016416053
Mean	0.9141469135
Median Absolute Deviation (MAD)	1
Skewness	1.143543888
Sum	10914
Variance	0.9742838487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5276	44.2%
2	3273	27.4%
1	3047	25.5%
4	175	1.5%
3	135	1.1%
6	18	0.2%
8	9	0.1%
5	4	< 0.1%
7	1	< 0.1%
9	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5276	44.2%
1	3047	25.5%
2	3273	27.4%
3	135	1.1%
4	175	1.5%
5	4	< 0.1%
6	18	0.2%
7	1	< 0.1%
8	9	0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
8	9	0.1%
7	1	< 0.1%
6	18	0.2%
5	4	< 0.1%
4	175	1.5%
3	135	1.1%
2	3273	27.4%
1	3047	25.5%
0	5276	44.2%

stays_in_week_nights
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	21
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.487729291

Minimum	0
Maximum	22
Zeros	771
Zeros (%)	6.5%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	22
Range	22
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.869170221
Coefficient of variation (CV)	0.7513559566
Kurtosis	13.4165766
Mean	2.487729291
Median Absolute Deviation (MAD)	1
Skewness	2.401236979
Sum	29701
Variance	3.493797315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2	3434	28.8%
1	2997	25.1%
3	2230	18.7%
5	1081	9.1%
4	948	7.9%
0	771	6.5%
6	139	1.2%
7	114	1.0%
10	88	0.7%
8	73	0.6%
Other values (11)	64	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	771	6.5%
1	2997	25.1%
2	3434	28.8%
3	2230	18.7%
4	948	7.9%
5	1081	9.1%
6	139	1.2%
7	114	1.0%
8	73	0.6%
9	23	0.2%

Value	Count	Frequency (%)
22	2	< 0.1%
21	4	< 0.1%
20	4	< 0.1%
19	3	< 0.1%
16	1	< 0.1%
15	12	0.1%
14	4	< 0.1%
13	3	< 0.1%
12	2	< 0.1%
11	6	0.1%

adults
Real number (ℝ_≥0)

SKEWED

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.853840355

Minimum	0
Maximum	40
Zeros	42
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	40
Range	40
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6048854144
Coefficient of variation (CV)	0.3262877587
Kurtosis	1324.471113
Mean	1.853840355
Median Absolute Deviation (MAD)	0
Skewness	20.76322339
Sum	22133
Variance	0.3658863645
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	8911	74.6%
1	2346	19.6%
3	632	5.3%
0	42	0.4%
4	6	0.1%
5	1	< 0.1%
40	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	42	0.4%
1	2346	19.6%
2	8911	74.6%
3	632	5.3%
4	6	0.1%
5	1	< 0.1%
40	1	< 0.1%

Value	Count	Frequency (%)
40	1	< 0.1%
5	1	< 0.1%
4	6	0.1%
3	632	5.3%
2	8911	74.6%
1	2346	19.6%
0	42	0.4%

children
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

0.0	11101
1.0	468
2.0	365
3.0	5

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	35817
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	11101	93.0%
1.0	468	3.9%
2.0	365	3.1%
3.0	5	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0.0	11101	93.0%
1.0	468	3.9%
2.0	365	3.1%
3.0	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	23040	64.3%
.	11939	33.3%
1	468	1.3%
2	365	1.0%
3	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	23878	66.7%
Other Punctuation	11939	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	23040	96.5%
1	468	2.0%
2	365	1.5%
3	5	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	11939	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35817	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	23040	64.3%
.	11939	33.3%
1	468	1.3%
2	365	1.0%
3	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35817	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	23040	64.3%
.	11939	33.3%
1	468	1.3%
2	365	1.0%
3	5	< 0.1%

babies
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

0	11832
1	105
2	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11939	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	11939	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11832	99.1%
1	105	0.9%
2	2	< 0.1%

meal
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	688.7 KiB

BB	9222
HB	1446
SC	1084
Undefined	99
FB	88

Length

Max length	9
Median length	2
Mean length	2.058045062
Min length	2

Characters and Unicode

Total characters	24571
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	9222	77.2%
HB	1446	12.1%
SC	1084	9.1%
Undefined	99	0.8%
FB	88	0.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
bb	9222	77.2%
hb	1446	12.1%
sc	1084	9.1%
undefined	99	0.8%
fb	88	0.7%

Most occurring characters

Value	Count	Frequency (%)
B	19978	81.3%
H	1446	5.9%
S	1084	4.4%
C	1084	4.4%
n	198	0.8%
d	198	0.8%
e	198	0.8%
U	99	0.4%
f	99	0.4%
i	99	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	23779	96.8%
Lowercase Letter	792	3.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	19978	84.0%
H	1446	6.1%
S	1084	4.6%
C	1084	4.6%
U	99	0.4%
F	88	0.4%

Lowercase Letter

Value	Count	Frequency (%)
n	198	25.0%
d	198	25.0%
e	198	25.0%
f	99	12.5%
i	99	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24571	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	19978	81.3%
H	1446	5.9%
S	1084	4.4%
C	1084	4.4%
n	198	0.8%
d	198	0.8%
e	198	0.8%
U	99	0.4%
f	99	0.4%
i	99	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	19978	81.3%
H	1446	5.9%
S	1084	4.4%
C	1084	4.4%
n	198	0.8%
d	198	0.8%
e	198	0.8%
U	99	0.4%
f	99	0.4%
i	99	0.4%

country
Categorical

HIGH CARDINALITY

Distinct	109
Distinct (%)	0.9%
Missing	48
Missing (%)	0.4%
Memory size	698.2 KiB

PRT	4880
GBR	1165
FRA	1009
ESP	866
DEU	729
Other values (104)	3242

Length

Max length	3
Median length	3
Mean length	2.989235556
Min length	2

Characters and Unicode

Total characters	35545
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.2%

Sample

1st row	FRA
2nd row	PRT
3rd row	FRA
4th row	GBR
5th row	FRA

Common Values

Value	Count	Frequency (%)
PRT	4880	40.9%
GBR	1165	9.8%
FRA	1009	8.5%
ESP	866	7.3%
DEU	729	6.1%
ITA	404	3.4%
IRL	323	2.7%
NLD	223	1.9%
BRA	222	1.9%
BEL	213	1.8%
Other values (99)	1857	15.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
prt	4880	41.0%
gbr	1165	9.8%
fra	1009	8.5%
esp	866	7.3%
deu	729	6.1%
ita	404	3.4%
irl	323	2.7%
nld	223	1.9%
bra	222	1.9%
bel	213	1.8%
Other values (99)	1857	15.6%

Most occurring characters

Value	Count	Frequency (%)
R	8033	22.6%
P	5896	16.6%
T	5485	15.4%
E	2161	6.1%
A	2135	6.0%
B	1632	4.6%
S	1410	4.0%
U	1353	3.8%
G	1262	3.6%
F	1057	3.0%
Other values (16)	5121	14.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35545	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	8033	22.6%
P	5896	16.6%
T	5485	15.4%
E	2161	6.1%
A	2135	6.0%
B	1632	4.6%
S	1410	4.0%
U	1353	3.8%
G	1262	3.6%
F	1057	3.0%
Other values (16)	5121	14.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35545	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	8033	22.6%
P	5896	16.6%
T	5485	15.4%
E	2161	6.1%
A	2135	6.0%
B	1632	4.6%
S	1410	4.0%
U	1353	3.8%
G	1262	3.6%
F	1057	3.0%
Other values (16)	5121	14.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35545	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	8033	22.6%
P	5896	16.6%
T	5485	15.4%
E	2161	6.1%
A	2135	6.0%
B	1632	4.6%
S	1410	4.0%
U	1353	3.8%
G	1262	3.6%
F	1057	3.0%
Other values (16)	5121	14.4%

market_segment
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	770.0 KiB

Online TA	5692
Offline TA/TO	2410
Groups	1957
Direct	1235
Corporate	542
Other values (2)	103

Length

Max length	13
Median length	9
Mean length	9.027724265
Min length	6

Characters and Unicode

Total characters	107782
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Online TA
3rd row	Offline TA/TO
4th row	Online TA
5th row	Direct

Common Values

Value	Count	Frequency (%)
Online TA	5692	47.7%
Offline TA/TO	2410	20.2%
Groups	1957	16.4%
Direct	1235	10.3%
Corporate	542	4.5%
Complementary	74	0.6%
Aviation	29	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
online	5692	28.4%
ta	5692	28.4%
ta/to	2410	12.0%
offline	2410	12.0%
groups	1957	9.8%
direct	1235	6.2%
corporate	542	2.7%
complementary	74	0.4%
aviation	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	13897	12.9%
O	10512	9.8%
T	10512	9.8%
e	10027	9.3%
i	9395	8.7%
l	8176	7.6%
A	8131	7.5%
	8102	7.5%
f	4820	4.5%
r	4350	4.0%
Other values (14)	19860	18.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	64307	59.7%
Uppercase Letter	32963	30.6%
Space Separator	8102	7.5%
Other Punctuation	2410	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	13897	21.6%
e	10027	15.6%
i	9395	14.6%
l	8176	12.7%
f	4820	7.5%
r	4350	6.8%
o	3144	4.9%
p	2573	4.0%
u	1957	3.0%
s	1957	3.0%
Other values (6)	4011	6.2%

Uppercase Letter

Value	Count	Frequency (%)
O	10512	31.9%
T	10512	31.9%
A	8131	24.7%
G	1957	5.9%
D	1235	3.7%
C	616	1.9%

Space Separator

Value	Count	Frequency (%)
	8102	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	2410	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	97270	90.2%
Common	10512	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	13897	14.3%
O	10512	10.8%
T	10512	10.8%
e	10027	10.3%
i	9395	9.7%
l	8176	8.4%
A	8131	8.4%
f	4820	5.0%
r	4350	4.5%
o	3144	3.2%
Other values (12)	14306	14.7%

Common

Value	Count	Frequency (%)
	8102	77.1%
/	2410	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	107782	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	13897	12.9%
O	10512	9.8%
T	10512	9.8%
e	10027	9.3%
i	9395	8.7%
l	8176	7.6%
A	8131	7.5%
	8102	7.5%
f	4820	4.5%
r	4350	4.0%
Other values (14)	19860	18.4%

distribution_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	726.9 KiB

TA/TO	9809
Direct	1461
Corporate	652
GDS	17

Length

Max length	9
Median length	5
Mean length	5.337968004
Min length	3

Characters and Unicode

Total characters	63730
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	TA/TO
3rd row	TA/TO
4th row	TA/TO
5th row	Direct

Common Values

Value	Count	Frequency (%)
TA/TO	9809	82.2%
Direct	1461	12.2%
Corporate	652	5.5%
GDS	17	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ta/to	9809	82.2%
direct	1461	12.2%
corporate	652	5.5%
gds	17	0.1%

Most occurring characters

Value	Count	Frequency (%)
T	19618	30.8%
A	9809	15.4%
/	9809	15.4%
O	9809	15.4%
r	2765	4.3%
e	2113	3.3%
t	2113	3.3%
D	1478	2.3%
i	1461	2.3%
c	1461	2.3%
Other values (6)	3294	5.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41400	65.0%
Lowercase Letter	12521	19.6%
Other Punctuation	9809	15.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	2765	22.1%
e	2113	16.9%
t	2113	16.9%
i	1461	11.7%
c	1461	11.7%
o	1304	10.4%
p	652	5.2%
a	652	5.2%

Uppercase Letter

Value	Count	Frequency (%)
T	19618	47.4%
A	9809	23.7%
O	9809	23.7%
D	1478	3.6%
C	652	1.6%
G	17	< 0.1%
S	17	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	9809	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53921	84.6%
Common	9809	15.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	19618	36.4%
A	9809	18.2%
O	9809	18.2%
r	2765	5.1%
e	2113	3.9%
t	2113	3.9%
D	1478	2.7%
i	1461	2.7%
c	1461	2.7%
o	1304	2.4%
Other values (5)	1990	3.7%

Common

Value	Count	Frequency (%)
/	9809	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63730	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	19618	30.8%
A	9809	15.4%
/	9809	15.4%
O	9809	15.4%
r	2765	4.3%
e	2113	3.3%
t	2113	3.3%
D	1478	2.3%
i	1461	2.3%
c	1461	2.3%
Other values (6)	3294	5.2%

is_repeated_guest
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

0	11562
1	377

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

Most occurring characters

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11939	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	11939	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11562	96.8%
1	377	3.2%

previous_cancellations
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.08895217355

Minimum	0
Maximum	26
Zeros	11325
Zeros (%)	94.9%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9283031604
Coefficient of variation (CV)	10.43598063
Kurtosis	617.4229725
Mean	0.08895217355
Median Absolute Deviation (MAD)	0
Skewness	23.75659833
Sum	1062
Variance	0.8617467576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	11325	94.9%
1	568	4.8%
2	15	0.1%
3	6	0.1%
24	6	0.1%
26	5	< 0.1%
11	4	< 0.1%
6	3	< 0.1%
25	3	< 0.1%
4	2	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11325	94.9%
1	568	4.8%
2	15	0.1%
3	6	0.1%
4	2	< 0.1%
6	3	< 0.1%
11	4	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
24	6	0.1%

Value	Count	Frequency (%)
26	5	< 0.1%
25	3	< 0.1%
24	6	0.1%
14	1	< 0.1%
13	1	< 0.1%
11	4	< 0.1%
6	3	< 0.1%
4	2	< 0.1%
3	6	0.1%
2	15	0.1%

previous_bookings_not_canceled
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	29
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.140882821

Minimum	0
Maximum	59
Zeros	11560
Zeros (%)	96.8%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	59
Range	59
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.465840309
Coefficient of variation (CV)	10.40467744
Kurtosis	661.5111628
Mean	0.140882821
Median Absolute Deviation (MAD)	0
Skewness	21.99555117
Sum	1682
Variance	2.148687812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	11560	96.8%
1	164	1.4%
2	57	0.5%
3	39	0.3%
4	18	0.2%
7	14	0.1%
5	14	0.1%
8	12	0.1%
6	12	0.1%
11	8	0.1%
Other values (19)	41	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11560	96.8%
1	164	1.4%
2	57	0.5%
3	39	0.3%
4	18	0.2%
5	14	0.1%
6	12	0.1%
7	14	0.1%
8	12	0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
59	1	< 0.1%
58	1	< 0.1%
45	1	< 0.1%
44	1	< 0.1%
33	1	< 0.1%
31	1	< 0.1%
28	1	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
21	2	< 0.1%

reserved_room_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	676.4 KiB

A	8612
D	1933
E	647
F	266
G	191
Other values (3)	290

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	E
3rd row	A
4th row	D
5th row	D

Common Values

Value	Count	Frequency (%)
A	8612	72.1%
D	1933	16.2%
E	647	5.4%
F	266	2.2%
G	191	1.6%
B	124	1.0%
C	111	0.9%
H	55	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
a	8612	72.1%
d	1933	16.2%
e	647	5.4%
f	266	2.2%
g	191	1.6%
b	124	1.0%
c	111	0.9%
h	55	0.5%

Most occurring characters

Value	Count	Frequency (%)
A	8612	72.1%
D	1933	16.2%
E	647	5.4%
F	266	2.2%
G	191	1.6%
B	124	1.0%
C	111	0.9%
H	55	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11939	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	8612	72.1%
D	1933	16.2%
E	647	5.4%
F	266	2.2%
G	191	1.6%
B	124	1.0%
C	111	0.9%
H	55	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11939	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	8612	72.1%
D	1933	16.2%
E	647	5.4%
F	266	2.2%
G	191	1.6%
B	124	1.0%
C	111	0.9%
H	55	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	8612	72.1%
D	1933	16.2%
E	647	5.4%
F	266	2.2%
G	191	1.6%
B	124	1.0%
C	111	0.9%
H	55	0.5%

assigned_room_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	676.4 KiB

A	7419
D	2555
E	768
F	354
C	250
Other values (5)	593

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	E
3rd row	A
4th row	D
5th row	D

Common Values

Value	Count	Frequency (%)
A	7419	62.1%
D	2555	21.4%
E	768	6.4%
F	354	3.0%
C	250	2.1%
G	241	2.0%
B	229	1.9%
H	65	0.5%
I	37	0.3%
K	21	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
a	7419	62.1%
d	2555	21.4%
e	768	6.4%
f	354	3.0%
c	250	2.1%
g	241	2.0%
b	229	1.9%
h	65	0.5%
i	37	0.3%
k	21	0.2%

Most occurring characters

Value	Count	Frequency (%)
A	7419	62.1%
D	2555	21.4%
E	768	6.4%
F	354	3.0%
C	250	2.1%
G	241	2.0%
B	229	1.9%
H	65	0.5%
I	37	0.3%
K	21	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11939	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	7419	62.1%
D	2555	21.4%
E	768	6.4%
F	354	3.0%
C	250	2.1%
G	241	2.0%
B	229	1.9%
H	65	0.5%
I	37	0.3%
K	21	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11939	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	7419	62.1%
D	2555	21.4%
E	768	6.4%
F	354	3.0%
C	250	2.1%
G	241	2.0%
B	229	1.9%
H	65	0.5%
I	37	0.3%
K	21	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	7419	62.1%
D	2555	21.4%
E	768	6.4%
F	354	3.0%
C	250	2.1%
G	241	2.0%
B	229	1.9%
H	65	0.5%
I	37	0.3%
K	21	0.2%

booking_changes
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2175224056

Minimum	0
Maximum	9
Zeros	10139
Zeros (%)	84.9%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6183174707
Coefficient of variation (CV)	2.842546124
Kurtosis	27.64457801
Mean	0.2175224056
Median Absolute Deviation (MAD)	0
Skewness	4.278352626
Sum	2597
Variance	0.3823164946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	10139	84.9%
1	1271	10.6%
2	371	3.1%
3	97	0.8%
4	36	0.3%
5	12	0.1%
6	7	0.1%
7	3	< 0.1%
9	2	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10139	84.9%
1	1271	10.6%
2	371	3.1%
3	97	0.8%
4	36	0.3%
5	12	0.1%
6	7	0.1%
7	3	< 0.1%
8	1	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	1	< 0.1%
7	3	< 0.1%
6	7	0.1%
5	12	0.1%
4	36	0.3%
3	97	0.8%
2	371	3.1%
1	1271	10.6%
0	10139	84.9%

deposit_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.3 KiB

No Deposit	10482
Non Refund	1437
Refundable	20

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	119390
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	10482	87.8%
Non Refund	1437	12.0%
Refundable	20	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
deposit	10482	43.9%
no	10482	43.9%
refund	1437	6.0%
non	1437	6.0%
refundable	20	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	22401	18.8%
e	11959	10.0%
N	11919	10.0%
	11919	10.0%
D	10482	8.8%
p	10482	8.8%
s	10482	8.8%
i	10482	8.8%
t	10482	8.8%
n	2894	2.4%
Other values (7)	5888	4.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	83613	70.0%
Uppercase Letter	23858	20.0%
Space Separator	11919	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	22401	26.8%
e	11959	14.3%
p	10482	12.5%
s	10482	12.5%
i	10482	12.5%
t	10482	12.5%
n	2894	3.5%
f	1457	1.7%
u	1457	1.7%
d	1457	1.7%
Other values (3)	60	0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	11919	50.0%
D	10482	43.9%
R	1457	6.1%

Space Separator

Value	Count	Frequency (%)
	11919	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	107471	90.0%
Common	11919	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	22401	20.8%
e	11959	11.1%
N	11919	11.1%
D	10482	9.8%
p	10482	9.8%
s	10482	9.8%
i	10482	9.8%
t	10482	9.8%
n	2894	2.7%
R	1457	1.4%
Other values (6)	4431	4.1%

Common

Value	Count	Frequency (%)
	11919	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	22401	18.8%
e	11959	10.0%
N	11919	10.0%
	11919	10.0%
D	10482	8.8%
p	10482	8.8%
s	10482	8.8%
i	10482	8.8%
t	10482	8.8%
n	2894	2.4%
Other values (7)	5888	4.9%

agent
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	223
Distinct (%)	2.2%
Missing	1635
Missing (%)	13.7%
Infinite	0
Infinite (%)	0.0%
Mean	86.44817547

Minimum	1
Maximum	531
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	14
Q3	229
95-th percentile	250
Maximum	531
Range	530
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	110.432807
Coefficient of variation (CV)	1.277445203
Kurtosis	0.01658087489
Mean	86.44817547
Median Absolute Deviation (MAD)	12
Skewness	1.095463857
Sum	890762
Variance	12195.40487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	3265	27.3%
240	1392	11.7%
1	664	5.6%
14	344	2.9%
6	328	2.7%
7	320	2.7%
250	299	2.5%
28	176	1.5%
241	170	1.4%
8	157	1.3%
Other values (213)	3189	26.7%
(Missing)	1635	13.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	664	5.6%
2	21	0.2%
3	117	1.0%
4	7	0.1%
5	38	0.3%
6	328	2.7%
7	320	2.7%
8	157	1.3%
9	3265	27.3%
10	22	0.2%

Value	Count	Frequency (%)
531	8	0.1%
527	3	< 0.1%
526	1	< 0.1%
509	1	< 0.1%
502	2	< 0.1%
495	6	0.1%
493	4	< 0.1%
492	4	< 0.1%
480	1	< 0.1%
479	3	< 0.1%

company
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	163
Distinct (%)	23.4%
Missing	11241
Missing (%)	94.2%
Infinite	0
Infinite (%)	0.0%
Mean	189

Minimum	9
Maximum	543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	9
5-th percentile	40
Q1	67
median	178
Q3	260
95-th percentile	428.75
Maximum	543
Range	534
Interquartile range (IQR)	193

Descriptive statistics

Standard deviation	131.6184216
Coefficient of variation (CV)	0.6963937649
Kurtosis	-0.4128483484
Mean	189
Median Absolute Deviation (MAD)	103
Skewness	0.6395076039
Sum	131922
Variance	17323.4089
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	91	0.8%
223	81	0.7%
45	28	0.2%
153	26	0.2%
67	25	0.2%
281	18	0.2%
219	14	0.1%
154	14	0.1%
174	13	0.1%
233	12	0.1%
Other values (153)	376	3.1%
(Missing)	11241	94.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9	3	< 0.1%
11	1	< 0.1%
12	2	< 0.1%
14	1	< 0.1%
16	1	< 0.1%
20	5	< 0.1%
28	2	< 0.1%
31	2	< 0.1%
38	3	< 0.1%
39	2	< 0.1%

Value	Count	Frequency (%)
543	1	< 0.1%
531	1	< 0.1%
528	1	< 0.1%
525	2	< 0.1%
521	1	< 0.1%
514	1	< 0.1%
512	1	< 0.1%
506	1	< 0.1%
504	1	< 0.1%
498	11	0.1%

days_in_waiting_list
Real number (ℝ_≥0)

ZEROS

Distinct	87
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.492336042

Minimum	0
Maximum	391
Zeros	11561
Zeros (%)	96.8%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	19.18989246
Coefficient of variation (CV)	7.699560629
Kurtosis	186.7271495
Mean	2.492336042
Median Absolute Deviation (MAD)	0
Skewness	12.16410697
Sum	29756
Variance	368.2519726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11561	96.8%
39	39	0.3%
58	23	0.2%
44	13	0.1%
31	11	0.1%
3	10	0.1%
63	10	0.1%
69	10	0.1%
62	9	0.1%
187	9	0.1%
Other values (77)	244	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11561	96.8%
1	2	< 0.1%
3	10	0.1%
4	1	< 0.1%
6	3	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	1	< 0.1%
15	4	< 0.1%
17	7	0.1%

Value	Count	Frequency (%)
391	8	0.1%
330	5	< 0.1%
236	4	< 0.1%
224	1	< 0.1%
223	6	0.1%
215	1	< 0.1%
207	4	< 0.1%
187	9	0.1%
178	1	< 0.1%
176	6	0.1%

customer_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	783.8 KiB

Transient	8950
Transient-Party	2521
Contract	404
Group	64

Length

Max length	15
Median length	9
Mean length	10.21165927
Min length	5

Characters and Unicode

Total characters	121917
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	8950	75.0%
Transient-Party	2521	21.1%
Contract	404	3.4%
Group	64	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
transient	8950	75.0%
transient-party	2521	21.1%
contract	404	3.4%
group	64	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	23346	19.1%
t	14800	12.1%
r	14460	11.9%
a	14396	11.8%
T	11471	9.4%
s	11471	9.4%
i	11471	9.4%
e	11471	9.4%
-	2521	2.1%
P	2521	2.1%
Other values (7)	3989	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	104936	86.1%
Uppercase Letter	14460	11.9%
Dash Punctuation	2521	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	23346	22.2%
t	14800	14.1%
r	14460	13.8%
a	14396	13.7%
s	11471	10.9%
i	11471	10.9%
e	11471	10.9%
y	2521	2.4%
o	468	0.4%
c	404	0.4%
Other values (2)	128	0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	11471	79.3%
P	2521	17.4%
C	404	2.8%
G	64	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	2521	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119396	97.9%
Common	2521	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	23346	19.6%
t	14800	12.4%
r	14460	12.1%
a	14396	12.1%
T	11471	9.6%
s	11471	9.6%
i	11471	9.6%
e	11471	9.6%
P	2521	2.1%
y	2521	2.1%
Other values (6)	1468	1.2%

Common

Value	Count	Frequency (%)
-	2521	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	121917	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	23346	19.1%
t	14800	12.1%
r	14460	11.9%
a	14396	11.8%
T	11471	9.4%
s	11471	9.4%
i	11471	9.4%
e	11471	9.4%
-	2521	2.1%
P	2521	2.1%
Other values (7)	3989	3.3%

adr
Real number (ℝ_≥0)

ZEROS

Distinct	2440
Distinct (%)	20.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.8099422

Minimum	0
Maximum	392
Zeros	204
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	38
Q1	69.43
median	95
Q3	126
95-th percentile	192
Maximum	392
Range	392
Interquartile range (IQR)	56.57

Descriptive statistics

Standard deviation	48.36573863
Coefficient of variation (CV)	0.4750590913
Kurtosis	1.939955893
Mean	101.8099422
Median Absolute Deviation (MAD)	28
Skewness	0.9767056269
Sum	1215508.9
Variance	2339.244673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	332	2.8%
75	280	2.3%
90	229	1.9%
65	222	1.9%
0	204	1.7%
80	195	1.6%
95	179	1.5%
120	164	1.4%
110	153	1.3%
85	150	1.3%
Other values (2430)	9831	82.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	204	1.7%
1	3	< 0.1%
1.56	1	< 0.1%
1.8	1	< 0.1%
2	2	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
6	8	0.1%
6.4	1	< 0.1%
6.67	1	< 0.1%

Value	Count	Frequency (%)
392	1	< 0.1%
387	1	< 0.1%
357	1	< 0.1%
349.63	1	< 0.1%
343	1	< 0.1%
340	2	< 0.1%
336.57	1	< 0.1%
330	1	< 0.1%
329.67	1	< 0.1%
328	2	< 0.1%

required_car_parking_spaces
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.4 KiB

0	11221
1	715
2	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11939
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11939	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	11939	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11221	94.0%
1	715	6.0%
2	3	< 0.1%

total_of_special_requests
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.569645699

Minimum	0
Maximum	5
Zeros	7020
Zeros (%)	58.8%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7871496621
Coefficient of variation (CV)	1.381823234
Kurtosis	1.5214115
Mean	0.569645699
Median Absolute Deviation (MAD)	0
Skewness	1.340795689
Sum	6801
Variance	0.6196045905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	7020	58.8%
1	3341	28.0%
2	1318	11.0%
3	221	1.9%
4	34	0.3%
5	5	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7020	58.8%
1	3341	28.0%
2	1318	11.0%
3	221	1.9%
4	34	0.3%
5	5	< 0.1%

Value	Count	Frequency (%)
5	5	< 0.1%
4	34	0.3%
3	221	1.9%
2	1318	11.0%
1	3341	28.0%
0	7020	58.8%

reservation_status
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	765.2 KiB

Check-Out	7526
Canceled	4292
No-Show	121

Length

Max length	9
Median length	9
Mean length	8.620236201
Min length	7

Characters and Unicode

Total characters	102917
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Check-Out
3rd row	Check-Out
4th row	Canceled
5th row	Check-Out

Common Values

Value	Count	Frequency (%)
Check-Out	7526	63.0%
Canceled	4292	35.9%
No-Show	121	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
check-out	7526	63.0%
canceled	4292	35.9%
no-show	121	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	16110	15.7%
C	11818	11.5%
c	11818	11.5%
h	7647	7.4%
-	7647	7.4%
k	7526	7.3%
O	7526	7.3%
u	7526	7.3%
t	7526	7.3%
a	4292	4.2%
Other values (7)	13481	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	75684	73.5%
Uppercase Letter	19586	19.0%
Dash Punctuation	7647	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	16110	21.3%
c	11818	15.6%
h	7647	10.1%
k	7526	9.9%
u	7526	9.9%
t	7526	9.9%
a	4292	5.7%
n	4292	5.7%
l	4292	5.7%
d	4292	5.7%
Other values (2)	363	0.5%

Uppercase Letter

Value	Count	Frequency (%)
C	11818	60.3%
O	7526	38.4%
N	121	0.6%
S	121	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	7647	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	95270	92.6%
Common	7647	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	16110	16.9%
C	11818	12.4%
c	11818	12.4%
h	7647	8.0%
k	7526	7.9%
O	7526	7.9%
u	7526	7.9%
t	7526	7.9%
a	4292	4.5%
n	4292	4.5%
Other values (6)	9189	9.6%

Common

Value	Count	Frequency (%)
-	7647	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102917	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	16110	15.7%
C	11818	11.5%
c	11818	11.5%
h	7647	7.4%
-	7647	7.4%
k	7526	7.3%
O	7526	7.3%
u	7526	7.3%
t	7526	7.3%
a	4292	4.2%
Other values (7)	13481	13.1%

reservation_status_date
Categorical

HIGH CARDINALITY

Distinct	852
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Memory size	758.0 KiB

21-10-15	137
06-07-15	77
25-11-16	73
18-01-16	73
01-01-15	69
Other values (847)	11510

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	95512
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	0.2%

Sample

1st row	30-11-15
2nd row	25-04-16
3rd row	03-01-16
4th row	27-11-16
5th row	27-04-16

Common Values

Value	Count	Frequency (%)
21-10-15	137	1.1%
06-07-15	77	0.6%
25-11-16	73	0.6%
18-01-16	73	0.6%
01-01-15	69	0.6%
07-12-16	47	0.4%
02-07-15	40	0.3%
31-01-17	37	0.3%
15-03-16	37	0.3%
09-02-16	36	0.3%
Other values (842)	11313	94.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
21-10-15	137	1.1%
06-07-15	77	0.6%
25-11-16	73	0.6%
18-01-16	73	0.6%
01-01-15	69	0.6%
07-12-16	47	0.4%
02-07-15	40	0.3%
31-01-17	37	0.3%
15-03-16	37	0.3%
09-02-16	36	0.3%
Other values (842)	11313	94.8%

Most occurring characters

Value	Count	Frequency (%)
-	23878	25.0%
1	21879	22.9%
0	15069	15.8%
6	7888	8.3%
2	6894	7.2%
7	6063	6.3%
5	4722	4.9%
3	2648	2.8%
8	2317	2.4%
9	2127	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	71634	75.0%
Dash Punctuation	23878	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	21879	30.5%
0	15069	21.0%
6	7888	11.0%
2	6894	9.6%
7	6063	8.5%
5	4722	6.6%
3	2648	3.7%
8	2317	3.2%
9	2127	3.0%
4	2027	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	23878	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	95512	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	23878	25.0%
1	21879	22.9%
0	15069	15.8%
6	7888	8.3%
2	6894	7.2%
7	6063	6.3%
5	4722	4.9%
3	2648	2.8%
8	2317	2.4%
9	2127	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	95512	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	23878	25.0%
1	21879	22.9%
0	15069	15.8%
6	7888	8.3%
2	6894	7.2%
7	6063	6.3%
5	4722	4.9%
3	2648	2.8%
8	2317	2.4%
9	2127	2.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	required_car_parking_spaces	total_of_special_requests	reservation_status	reservation_status_date
0	80965	City Hotel	0	2	2015	November	48	27	1	2	2	BB	FRA	Direct	Direct	D	D	0	No Deposit	14.0	NaN	Transient	85.00	0	0	Check-Out	30-11-15
1	23416	Resort Hotel	0	27	2016	April	17	22	1	2	2	BB	PRT	Online TA	TA/TO	E	E	0	No Deposit	240.0	NaN	Transient	85.00	0	1	Check-Out	25-04-16
2	82624	City Hotel	0	40	2015	December	53	31	0	3	2	BB	FRA	Offline TA/TO	TA/TO	A	A	0	No Deposit	104.0	NaN	Transient	118.00	0	0	Check-Out	03-01-16
3	62104	City Hotel	1	123	2017	January	1	2	1	1	2	BB	GBR	Online TA	TA/TO	D	D	0	No Deposit	9.0	NaN	Transient	102.60	0	1	Canceled	27-11-16
4	87859	City Hotel	0	68	2016	April	17	23	2	2	2	BB	FRA	Direct	Direct	D	D	0	No Deposit	NaN	NaN	Transient	102.85	0	0	Check-Out	27-04-16
5	25646	Resort Hotel	0	158	2016	June	27	28	2	5	2	BB	CHE	Direct	Direct	E	F	0	No Deposit	NaN	NaN	Transient	131.50	1	1	Check-Out	05-07-16
6	52161	City Hotel	1	113	2016	May	23	31	0	3	1	BB	PRT	Corporate	TA/TO	A	A	0	Non Refund	NaN	202.0	Transient	100.00	0	0	Canceled	11-04-16
7	57010	City Hotel	1	205	2016	September	38	16	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	37.0	NaN	Transient	120.00	0	0	Canceled	15-03-16
8	43958	City Hotel	1	88	2015	September	39	26	2	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	1.0	NaN	Transient	170.00	0	0	Canceled	09-09-15
9	79032	City Hotel	0	0	2015	October	43	20	0	1	1	BB	ITA	Offline TA/TO	TA/TO	A	B	1	No Deposit	87.0	NaN	Transient	123.00	0	0	Check-Out	21-10-15

Last rows

	df_index	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	previous_cancellations	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date
11929	66021	City Hotel	1	106	2017	April	15	13	0	2	2	SC	ESP	Online TA	TA/TO	0	A	A	0	No Deposit	9.0	NaN	Transient	108.00	0	Canceled	01-01-17
11930	62215	City Hotel	1	545	2017	January	1	5	0	2	2	BB	PRT	Groups	TA/TO	0	A	A	0	Non Refund	1.0	NaN	Transient	62.00	0	Canceled	21-10-15
11931	20374	Resort Hotel	0	4	2016	January	5	26	0	1	1	BB	PRT	Corporate	Corporate	0	A	D	0	No Deposit	NaN	NaN	Transient	38.00	0	Check-Out	27-01-16
11932	22464	Resort Hotel	0	36	2016	March	13	24	0	3	3	BB	PRT	Offline TA/TO	TA/TO	0	D	D	0	No Deposit	314.0	NaN	Transient	81.00	1	Check-Out	27-03-16
11933	6487	Resort Hotel	1	221	2016	June	25	12	3	5	2	BB	PRT	Direct	Direct	0	G	G	0	No Deposit	250.0	NaN	Transient	114.75	1	Canceled	09-11-15
11934	77023	City Hotel	0	14	2015	September	36	1	0	1	2	BB	PRT	Online TA	TA/TO	0	A	D	0	No Deposit	9.0	NaN	Contract	105.00	2	Check-Out	02-09-15
11935	57541	City Hotel	1	250	2016	September	40	26	1	3	2	BB	PRT	Offline TA/TO	TA/TO	0	A	A	0	Non Refund	3.0	NaN	Transient	95.00	0	Canceled	28-06-16
11936	82770	City Hotel	1	68	2016	February	8	17	0	2	2	BB	PRT	Groups	TA/TO	1	A	A	0	Non Refund	37.0	NaN	Transient	75.00	0	Canceled	06-01-16
11937	109861	City Hotel	0	177	2017	April	15	15	2	1	2	HB	CN	Groups	TA/TO	0	A	A	1	No Deposit	2.0	NaN	Transient-Party	105.33	1	Check-Out	18-04-17
11938	34515	Resort Hotel	0	241	2017	March	12	21	2	5	1	BB	GBR	Groups	TA/TO	0	A	A	0	No Deposit	273.0	NaN	Transient-Party	28.80	0	Check-Out	28-03-17

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script